This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



~Lily Ekrethernivu
Sep 9, 2013, 3:35 PM
51 Posts

Export to excel

  • Category: Other
  • Platform: Windows
  • Release: 8.5.2
  • Role: Developer
  • Tags: Export to excel using Lotusscript
  • Replies: 2

Dear All,


I have created a view named "testview" in domino directory, this view contains personname, mailserver and emailaddress. Now I want to create an agent to export this view to excel automatically and I would also schedule to run every night. the excel file need to overwrite. lets say the path of the excel file is C:\view\testview.xls

Can i possible to do this with lotusscript agent.

Thanks,

~Cheryl Elhipigenlen
Sep 9, 2013, 5:08 PM
366 Posts
Not without installing office on the server

 in order to do it via lotusscipt you have to install Office on the server to make the com calls.

I use Apache's POI java library that is open source and allows for the export/import/manipulation of Excel files 

 

http://poi.apache.org/


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal